Java Database Programming with JDBC Java Database Programming with JDBC
by Pratik Patel
Coriolis, The Coriolis Group
ISBN: 1576100561   Pub Date: 10/01/96
  

Previous Table of Contents Next


Methods

Method Name Additional Description
public abstract boolean
allProceduresAreCallable() throwsk
SQLException
Returns true if all the procedures available to the user are callable
public abstract boolean
allTablesAreSelectable() throws SQLException
Returns true if all of the tables are accessible to the user on the open connection
public abstract boolean
dataDefinitionCausesTransactionCommit() throws SQLException
Returns true if data defintion causes the transaction to commit
public abstract boolean
dataDefinitionIgnoredInTransactions()
throws SQLException
Returns true if data defintion is ignored in the transaction
public abstract boolean
doesMaxRowSizeIncludeBlobs() throws
SQLException
Returns true if the getMaxSize method does not account for the size of LONGVARCHAR and LONGVARBINARY SQL data types
public abstract ResultSet
getBestRowIdentifier(String catalog, String
schema, String table, int scope, boolean
nullok) throws SQLException
Returns a ResultSet object for the specified parameters that gets the specified table’s key or the attributes that can be used to uniquely identify a row, which may be composite; the scope parameter is one of the constants: bestRowTemporary, bestRowTransaction, or betRowSession; the nullok parameter allows columns that may be null; the ResultSet is composed of the following columns: scope (of the same types as above scope parameter), column name, SQL data type, name of the data type dependent on the database, precision, buffer length, significant places if a Numeric type, and pseudo column (one of the constants bestRowUnknown, bestRowNotPseudo, or bestRowPseudo)
public abstract ResultSet getCatalogs()
throws SQLException
Returns a ResultSet object that contains a column for the catalog names that are in the database
public abstract
String getCatalogSeparator() throws
SQLException
Returns the separator between the catalog String and the table name
public abstract String getCatalogTerm()
throws SQLException
Returns the database-specific term for “catalog”
public abstract ResultSet
getColumnPrivileges(String catalog,
String schemaString table, String
columnNamePattern) throws SQLException
Returns a ResultSet object that contains information about the specified table’s matching columnNamePattern; the returned ResultSet object contains the following columns: the catalog name that the table is in, the schema the table is in, the table name, the column name, owner of the table, grantee, type of access (SELECT, UPDATE, etc.), and if the grantee can grant access to others, “YES,” “NO,” or null (if unknown)
public abstract ResultSet
getColumns(String catalog,
String schemaPattern, String tableNamePattern,
String columnNamePattern) throws
SQLException
Returns a ResultSet object that contains information about the matching columns for the matching tables and schemas; the ResultSet contains the following columns: catalog name, schema name, table name, column name, SQL data type, name of the type specific to the database, the maximum number of characters or precision depending on the data type, buffer length (not used), the number of digits (if applicable), radix (if applicable), null-ability (one of the constants columnNoNulls, columnNullable, columnNullableUnknown), comments for the column, default value (if it exists, else null), empty column, empty column, maximum number of bytes in the column of type CHAR (if applicable), index number of column; the last column is set to “YES” if it can contain NULLS if not “NO” else it’s empty if the status is unknown
public abstract ResultSet get
CrossReference(String primaryCatalog,
String primarySchema,
String primaryTable, String foreignCatalog,
String foreignSchema, String foreignTable)
throws SQLException
Returns a ResultSet object that describes the way a table imports foreign keys; the ResultSet object returned by this method contains these columns: primary key’s table catalog, primary key’s table schema, primary key’s table, primary key’s column name, foreign key’s table catalog, foreign key’s table schema, foreign key’s table, foreign key’s column name, sequence number within foreign key, action to foreign key when primary key is updated (one of the constants importedKeyCascade, importedKeyRestrict, importedKeySetNull), action to foreign key when primary key is deleted (one of the constants importedKeyCascade, importedKeyRestrict, importedKeySetNull), foreign key identifier, and primary key indentifier
public abstract String
getDatabaseProductName() throws
SQLException
Returns the database product name
public abstract String
getDatabaseProductVersion() throws
SQLException
Returns the database product number
public abstract int
getDefaultTransactionIsolation() throws
SQLException
Returns the default transaction isolation level as defined by the applicable constants in the Connection class
public abstract int
getDriverMajorVersion()
Gets the driver’s major version
public abstract int
getDriverMinorVersion()
Gets the driver’s minor version
public abstract String getDriverName()
throws SQLException
Returns the name of the JDBC driver
public abstract String getDriverVersion()
throws SQLException
Returns the version of the JDBC driver
public abstract ResultSet
getExportedKeys(String catalog, String
schema, String table) throws SQLException
Returns a ResultSet object that describes the foreign key attributes that reference the specified table’s primary key; the ResultSet object returns the following columns: primary key’s table catalog, primary key’s table schema, primary key’s table, primary key’s column name, foreign key’s table catalog, foreign key’s table schema, foreign key’s table, foreign key’s column name, sequence number within foreign key, action to foreign key when primary key is updated (one of the constants importedKeyCascade, importedKeyRestrict, importedKeySetNull), action to foreign key when primary key is deleted (one of the constants importedKeyCascade, importedKeyRestrict, importedKeySetNull), foreign key identifier, and primary key indentifier
public abstract String
getExtraNameCharacters() throws
SQLException
Returns characters that can be used in unquoted identifier names besides the standard A through Z, 0 through 9, and _
public abstract String
getIdentifierQuoteString() throws
SQLException
Returns the String used to quote SQL identifiers
public abstract ResultSet
getImportedKeys(String String schema,
String table) throws SQLException
Returns a ResultSet object that describes the primary key attributes that are referenced by the specified table’s foreign key attributes; the ResultSet object contains the following columns: primary key’s table catalog, primary key’s table schema, primary key’s table, primary key’s column name, foreign key’s table catalog, foreign key’s table schema, foreign key’s table, foreign key’s column name, sequence number within foreign key, action to foreign key when primary key is updated (one of the constants importedKeyCascade, importedKeyRestrict, importedKeySetNull), action to foreign key when primary key is deleted (one of the constants importedKeyCascade, importedKeyRestrict, importedKeySetNull), foreign key identifier, and primary key indentifier
public abstract ResultSet
getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException
Returns a ResultSet object that describes the specified table’s indices and statistics; the ResultSet object contains the following columns: catalog name, schema name, table name, “false” boolean (if tableIndexStatic is the type), index catalog (or null if type is tableIndexStatic), index type, sequence number, column name, column sort sequence, number of unique values in the table or number of rows (if tableIndexStatic), number of pages used for the index (or the number of pages used for the table if tableIndexStatic), and filter condition (if it exists)
public abstract int
getMaxBinaryLiteralLength() throws
SQLException
Returns the number of hex characters allowed in an inline binary literal
public abstract int
getMaxCatalogNameLength() throws
SQLException
The maximum length for a catalog name
public abstract int
getMaxCharLiteralLength() throws
SQLException
Returns the maximum length for a character literal
public abstract int
getMaxColumnNameLength() throws
SQLException
Indicates the maximum length for a column name
public abstract int
getMaxColumnsInGroupBy() throws
SQLException
Indicates the maximum number of columns in a GROUP BY clause
public abstract int
getMaxColumnsInIndex() throws
SQLException
Indicates the maximum number of columns in an index
public abstract int
getMaxColumnsInOrderBy() throws
SQLException
Indicates the maximum number of columns allowed in a ORDER BY clause
public abstract int
getMaxColumnsInSelect() throws
SQLException
Indicates the maximum number of columns in a SELECT statement
public abstract int
getMaxColumnsInTable() throws
SQLException
Indicates the maximum number of columns allowed in a table
public abstract int getMaxConnections()
throws SQLException
Indicates the maximum number of simultaneous connections allowed to the database
public abstract int
getMaxCursorNameLength() throws
SQLException
Returns the maximum allowed length of a cursor name
public abstract int
getMaxIndexLength() throws
SQLException
Returns the maximum length of an index in bytes
public abstract int
getMaxProcedureNameLength() throws
SQLException
Returns the maximum allowed length of a procedure name
public abstract int getMaxRowSize()
throws SQLException
Indicates the maximum row size
public abstract int
getMaxSchemaNameLength() throws
SQLException
Returns the maximum allowed length of a schema name
public abstract int
getMaxStatementLength() throws
SQLException
Returns the maximum allowed length of a SQL statement
public abstract int getMaxStatements() throws SQLException Returns the maximum number of statements allowed at one time
public abstract int
getMaxTableNameLength() throws
SQLException
Returns the maximum allowed length of a table name
public abstract int getMaxTablesInSelect()
throws SQLException
Indicates the maximum number of tables allowed in a SELECT statement
public abstract int
getMaxUserNameLength() throws
SQLException
Returns the maximum allowed length of a user name
public abstract String
getNumericFunctions() throws
SQLException
Returns a comma-separated list of the math functions available
public abstract
ResultSet getPrimaryKeys(String catalog,
String schema, String table) throws
SQLException
Returns a ResultSet object that contains the primary key’s description for the specified table; the ResultSet object contains the following columns: catalog name, schema name, table name, column name, sequence number, primary key name, and, possibly, NULL
public abstract ResultSet
getProcedureColumns(String catalog,
String schemaPattern, String
procedureNamePattern, String
columnNamePattern) throws SQLException
Returns a ResultSet object that describes the catalog’s stored procedures and result columns matching the specified procedureNamePatten and columnNamePattern; the ResultSet object contains the following columns: catalog name, schema name, procedure name, column or parameter name, column type, data type, data name, precision, length in bytes, scale, radix, nullability, and comments
public abstract ResultSet
getProcedures(String catalogString String
procedureNamePattern) throws
SQLException
Returns a ResultSet object that describes the catalog’s procedures; the ResultSet object contains the following columns: catalog name, schema name, procedure name, empty column, empty column, empty column, comments about the procedure, and kind of procedure
public abstract String
getProcedureTerm() throws SQLException
Return the database-specific term for procedure
public abstract ResultSet getSchemas()
throws SQLException
Returns a ResultSet object that describes the schemas in a database; the ResultSet object contains one column that contains the schema names
public abstract String
getSchemaTerm() throws
SQLException
Returns the database-specific term for schema
public abstract String
getSearchStringEscape() throws
SQLException
Returns the escape characters for pattern searching
public abstract String getSQLKeywords()
throws SQLException
Returns a comma-separated list of keywords that the database recognizes, but the keywords are not SQL-92 keywords
public abstract String getStringFunctions()
throws SQLException
Returns a comma-separated list of string functions in the database
public abstract String getSystemFunctions() throws SQLException Returns a comma-separated list of system functions in the database
public abstract ResultSet
getTablePrivileges(String catalog, String
schemaPattern schemaPattern, String
tableNamePattern)
throws SQLException
Returns a ResultSet object that describes the privileges for the matching and tableNamePattern; the ResultSet object contains the following columns: catalog name, schema name, table name, grantor, grantee, type of access, and “YES” if a grantee can grant other access
public abstract ResultSet getTables(String
catalog, String schemaPattern, String
tableNamePattern, String types[])
throws SQLException
Returns a ResultSet object that describes tables matching the schemaPattern and tableNamePattern; the ResultSet object contains the following columns: catalog name, schema name, table name, table type, and comments
public abstract ResultSet getTableTypes()
throws SQLException
Returns a ResultSet object that describes the table types available in the database; the ResultSet object contains the column that is a list of the table types
public abstract String
getTimeDateFunctions() throws
SQLException
Returns the date and time functions for the database
public abstract ResultSet getTypeInfo()
throws SQLException
Returns a ResultSet object that describes the SQL data types supported by the database; the ResultSet object contains the columns: type name, SQL data type constants in the Types class, maximum precision, prefix used to quote a literal, suffix used to quote a literal, parameters used to create the type, nullability, case sensitivity, searchability, signed or unsigned (boolean), is it a currency, auto incrementable or not, local version of data type, minimum scale, maximum scale, empty column, empty column, and radix
public abstract String getURL() throws
SQLException
The URL for the database
public abstract String getUserName()
throws SQLException
Returns the user name as known by the database
public abstract ResultSet
getVersionColumns(String catalog,
String String table) throws SQLException
Returns a ResultSet object that describes the specified table’s columns that are updated when any column is updated in the table; the ResultSet object contains the following columns: empty columns, column name, SQL datatype, type name, precision, column value length in bytes, scale, and pseudoColumn or not
public abstract boolean isCatalogAtStart()
throws SQLException
Returns true if the catalog name appears at the start of a qualified table name
public abstract boolean isReadOnly()
throws SQLException
Returns true if the database is in read only mode
public abstract boolean
nullPlusNonNullIsNull() throws
SQLException
Returns true if a concatenation between a NULL and non-NULL is NULL
public abstract boolean
nullsAreSortedAtEnd()
throws SQLException
public abstract boolean
nullsAreSortedAtStart()
throws SQLException
public abstract boolean
nullsAreSortedHigh()
throws SQLException
public abstract boolean
nullsAreSortedLow()
throws SQLException
public abstract boolean
storesLowerCaseIdentifiers()
throws SQLException
public abstract boolean
storesLowerCaseQuotedIdentifiers() throws SQLException
public abstract boolean
storesMixedCaseIdentifiers() throws SQLException
public abstract boolean
storesMixedCaseQuotedIdentifiers() throws SQLException
public abstract boolean
storesUpperCaseIdentifiers()
throws SQLException
public abstract boolean
storesUpperCaseQuotedIdentifiers() throws SQLException
public abstract boolean
supportsAlterTableWithAddColumn() throws SQLException
public abstract boolean
supportsAlterTableWithDropColumn() throws SQLException
public abstract boolean
supportsAlterTableWithDropColumn() throws SQLException
public abstract boolean
supportsANSI92EntryLevelSQL() throws SQLException
public abstract boolean
supportsANSI92FullSQL() throws SQLException
public abstract boolean
supportsANSI92IntermediateSQL() throws SQLException
public abstract boolean
supportsANSI92FullSQL() throws SQLException
public abstract boolean
supportsCatalogsInDataManipulation() throws SQLException
public abstract boolean
supportsCatalogsInIndexDefinitions() throws SQLException
public abstract boolean
supportsCatalogsInPrivilegeDefinitions() throws SQLException
public abstract boolean
supportsCatalogsInProcedureCalls() throws SQLException
public abstract boolean
supportsCatalogsInTableDefinitions() throws SQLException
public abstract boolean
supportsColumnAliasing() throws SQLException
public abstract boolean
supportsConvert() throws SQLException
public abstract boolean
supportsConvert(int fromType, int toType) throws SQLException
public abstract boolean
supportsCoreSQLGrammar() throws SQLException
public abstract boolean
supportsCorrelatedSubqueries() throws SQLException
public abstract boolean
supportsDataDefinitionAnd
DataManipulationTransactions() throws SQLException
public abstract boolean
supportsDataManipulation
TransactionsOnly() throws SQLException
public abstract boolean
supportsDifferentTableCorrelationNames() throws SQLException
public abstract boolean
supportsExpressionsInOrderBy() throws SQLException
public abstract boolean
supportsExtendedSQLGrammar() throws SQLException
public abstract boolean
supportsFullOuterJoins() throws SQLException
public abstract boolean
supportsGroupBy() throws SQLException
public abstract boolean
supportsGroupByBeyondSelect() throws SQLException
public abstract boolean
supportsGroupByUnrelated() throws SQLException
public abstract boolean
supportsIntegrityEnhancementFacility() throws SQLException
public abstract boolean
supportsLikeEscapeClause() throws SQLException
public abstract boolean
supportsLimitedOuterJoins() throws SQLException
public abstract boolean
supportsMinimumSQLGrammar() throws SQLException
public abstract boolean
supportsMixedCaseIdentifiers() throws SQLException
public abstract boolean
supportsMixedCaseQuotedIdentifiers() throws SQLException
public abstract boolean
supportsMultipleResultSets() throws SQLException
public abstract boolean
supportsMultipleTransactions() throws SQLException
public abstract boolean
supportsNonNullableColumns() throws SQLException
public abstract boolean
supportsOpenCursorsAcrossCommit() throws SQLException
public abstract boolean
supportsOpenCursorsAcrossRollback() throws SQLException
public abstract boolean
supportsOpenStatementsAcrossCommit() throws SQLException
public abstract boolean
supportsOpenStatementsAcrossRollback() throws SQLException
public abstract boolean
supportsOrderByUnrelated()
throws SQLException
public abstract boolean
supportsOuterJoins()
throws SQLException
public abstract boolean
supportsPositionedDelete()
throws SQLException
public abstract boolean
supportsPositionedUpdate()
throws SQLException
public abstract boolean
supportsSchemasInDataManipulation()
throws SQLException
public abstract boolean
supportsSchemasInProcedureCalls()
throws SQLException
public abstract boolean
supportsSchemasInProcedureCalls()
throws SQLException
public abstract boolean
supportsSchemasInTableDefinitions()
throws SQLException
public abstract boolean
supportsSelectForUpdate()
throws SQLException
public abstract boolean
supportsStoredProcedures()
throws SQLException
public abstract boolean
supportsSubqueriesInComparisons()
throws SQLException
public abstract boolean
supportsSubqueriesInExists()
throws SQLException
public abstract boolean
supportsSubqueriesInIns()
throws SQLException
public abstract boolean
supportsSubqueriesInQuantifieds()
throws SQLException
public abstract boolean
supportsTableCorrelationNames() throws SQLException
public abstract boolean
supportsTransactionIsolationLevel(int level) throws SQLException
public abstract boolean
supportsTransactions() throws SQLException
public abstract boolean
supportsUnion() throws SQLException
public abstract boolean
supportsUnionAll() throws SQLException
public abstract boolean
usesLocalFilePerTable() throws SQLException
public abstract boolean
usesLocalFiles() throws SQLException


Previous Table of Contents Next